---
title: "SQL-035: Max policy effective date"
summary: Retrieve the latest policy period effective date for a policy.
status: draft
owner: SAIF Corporation
last_reviewed: 2026-08-21
library: SAIF.Business.View.Policy
reference_type: embedded
---

# SQL-035 Max policy effective date

This SQL retrieves the maximum policy period effective date for a policy so association retrieval can default missing date filters.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-035 |
| **Operation type** | Read |
| **Execution method** | Inline |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `PolicyAssociationList` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `GetMaxPolicyEffectiveDate` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:PolicyNumber` | Input | Decimal | N/A | Policy number whose latest policy period effective date is requested. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [POLICY_PERIOD](../database-tables.md#policy_period) | SELECT | `policy_num`, `policy_period_eff_date` |

## Sample SQL

```sql
SELECT
  MAX(policy_period_eff_date)
FROM policy_period pp
WHERE pp.policy_num = :PolicyNumber
```

## Operations and processes
- [Retrieve policy associations](../operations-processes.md)

## Business rules
- [BR-VP-024: Default association dates](../business-rules.md#br-vp-024-default-association-dates)

## Sources
- `SAIF.Business.View.Policy/PolicyAssociations.vb`